package com.un.ebs.quality.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.un.ebs.quality.domain.QualityCheck;
import org.apache.ibatis.annotations.Select;

/**
 * (QualityCheck)表数据库访问层
 *
 * @author liubo
 * @since 2020-11-15 20:09:03
 */
public interface QualityCheckMapper extends BaseMapper<QualityCheck> {

    @Select("SELECT COUNT(*)+1 FROM dbo.tb_quality_check WHERE CONVERT(VARCHAR(10),create_time,112)=CONVERT(VARCHAR(10),GETDATE(),112)")
    int maxCode();
}